import pandas as pd
import AutoRegistController

f_path = r'/Users/derek/Documents/derekworkspace/aicloudWorkspace/cross-commerce/test.xlsx'

excel_file = pd.read_excel(f_path, sheet_name=None)


def readExcel(f_path, sheetname):
    print('=============================================')
    data =  pd.read_excel(f_path, sheet_name=sheetname)
    print(data.columns[10])
    df = pd.DataFrame(data)
    # for index, row in df.iterrows():
    #     print('Index: ', index)
    #     print('Name: ', row['realName'])
        # print('Age: ', row['Age'])
        # print('City: ', row['City'])
    AutoRegistController.AutoRegister.init_seleconnect(data.columns[10],df)
    # print(data)


for i in excel_file.keys():
    readExcel(f_path,i)

